vaccinegaptype
Table Name: vaccinegaptype
The vaccinegaptype table defines the types of vaccine gaps, categorizing the various gap rules that apply between vaccine administrations.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| vaccineGapTypeId | smallint(6) | Primary Key, Not Null | Unique identifier for the vaccine gap type. |
| name | varchar(255) | Nullable | Name or description of the vaccine gap type (e.g., "Next Vaccine Gap"). |
Indexes
- Primary Key:
- vaccineGapTypeId: Ensures unique identification of each vaccine gap type.
Usage Notes
- Purpose:
- Categorizes and describes different types of gaps between vaccine doses.
- Acts as a reference table to provide meaningful labels for vaccinegap entries.
- Key Attributes:
- vaccineGapTypeId: Acts as a foreign key in the vaccinegap table, linking specific gap rules to their respective categories.
- name: Provides a human-readable label or description for the gap type, aiding in understanding and maintenance.